Modifying a DB Driver

To modify a DB driver, type 1 in the Opt field in the Work with DB Drivers screen (STRDB > 11) for the DB driver you want to update then press Enter. The Modify DB Driver screen appears:

​                              ​ Modify DB Driver​                                                                                                                   ​ Driver . . . . .​ ​ FIREBIRD  ​ Firebird                                           ​ Driver file  . .​ ​ firebird/jaybird-full-2.1.6.jar                             ​                    ​                                                             ​  ​ Class  . . . . .​ ​ org.firebirdsql.jdbc.FBDriver                               ​  ​                  ​                                                             ​  ​ Driver page  . .​ ​ http://www.firebirdsql.org                                  ​                    ​                                                             ​  ​ Default port . .​ ​  3050​                                                         ​ Additional parms​ ​ Label​               ​ Possible values​                          ​ Parm 1 . .<adl1>​ ​ file                ​                               ​           ​ Parm 2 . .<adl2>​ ​                     ​                               ​           ​ Parm 3 . .<adl3>​ ​                     ​                               ​           ​ Parm 4 . .<adl4>​ ​                     ​                               ​           ​ URL dft schema .​ ​ jdbc:firebirdsql://<host>:<port>/<adl1>                     ​  ​ Std replacement:​ ​                                                             ​  ​ <host><db>      ​ ​                                                             ​  ​ <catalog><port> ​ ​                                                             ​  ​ <schema><adl1-4>​ ​                                                             ​                                                                                   ​ F3=Exit​              ​ F7=Driver page​  ​ F9=Restore Default​          ​ F12=Cancel​  ​                                                                                                                                                                  ​

The screen contains these fields:

Driver

The driver name and a free-form text description, as they appear on the Work with DB Drivers screen. The driver name is read-only.

Driver file

The path to the jar file on the IFS that contains the JDBC driver for this database. This can be either an absolute path, beginning with the "/" character, or relative to the default path, /iSecurity/DB‑Gate/Drivers

Class

The JDBC driver class name.

Driver page

The URL of the web page for driver information on the developer's web site.

To view the web page in your local computer's default browser, press the F7 key.

Default port

The default port to use in setting up a connection.

Additional parms

Up to four additional parameters that can be specified in connecting to the database, as in the URL dft schema field. For each, you can specify a Label and a free-form description of Possible values. The four parameters are referenced by the strings <adl1> through <adl4>.

URL dft schema

The default schema used in connecting to the database. The schema can automatically substitute the values of the variables <host>, <db>, <catalog>, <port>, <schema>, and the four parameters specified in the Additional parms field.

In the example value, jdbc:firebirdsql://<host>:<port>/<adl1> , the host name, port, and "file" value specified in the first additional parameter would be included in the schema when it is used.

To save the values that you have entered, press Enter. A confirmation message appears asking if you want to modify any of the entries. Press Enter again to save the changes to the driver.

To revert to the original definition of the driver as it was supplied, press the F8 key.